I recently moved from 7.1.3 to 7.2.1. In doing so, my application broke. It relies on INSERT returning the OID of the
insertedrow, even if the INSERT was on a view. I saw a note in the 7.2.1 notes about fixing a problem in this area,
perhapsmore needs to be done?
Example:
acropolis=# create table shad (a integer);
CREATE
acropolis=# create view shadview as select * from shad;
CREATE
acropolis=# create rule shadview_insert as on insert to shadview do instead insert into shad values (new.a);
CREATE
acropolis=# insert into shad values (1);
INSERT 3876425 1
acropolis=# insert into shadview values (2);
INSERT 0 0
acropolis=# select * from shad;
a
---
1
2
(2 rows)
---------------
Shouldn't the second INSERT return an OID as well?
Thanks,
-Damon